﻿CREATE TABLE [CoffeeShop].[Consumption] (
    [ConsumptionId]         INT            IDENTITY (1, 1) NOT NULL,
    [OrderId]               INT            NOT NULL,
    [UserId]                INT            NOT NULL,
    [UserName]              NVARCHAR (MAX) NOT NULL,
    [TotalPrice]            FLOAT          NOT NULL,
    [DeliveryPrice]         FLOAT          NOT NULL,
    [ComBervarage]          FLOAT          NOT NULL,
    [IsIrrevocableChoice]   BIT            NOT NULL,
    [TipPrice]              FLOAT          NOT NULL,
    [ConsumptionStatusCode] NCHAR (10)     NOT NULL
);

